{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Assignments","Totals","Student Reports","LetterConversion","Seating & Reminders"],"not_rendered":{"charts":2,"images":15,"macros":1,"external_links":1,"defined_names":1,"comments":9},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Assignments","index":0,"n_rows":21,"n_cols":21,"rows_kept":21,"flags":["formulas_cached_only"]}
[{"$nulls":6},"ZOOM:",null,"ACTIVITY","% of GRADE"]
[{"$nulls":8},"QUIZ",{"v":0.3,"d":"30%"}]
[{"$nulls":8},"TEST",{"v":0.25,"d":"25%"}]
[{"$nulls":8},"PAPER",{"v":0.15,"d":"15%"}]
[{"$nulls":8},"PROJECT",{"v":0.2,"d":"20%"}]
[{"$nulls":8},"LAB",{"v":0.1,"d":"10%"}]
[]
["INSTRUCTOR:","SUBJECT:","TIME:",null,"SEMESTER:",null,"DAYS:","Room","TOTAL:",{"v":1.0000000000000002,"d":"100%"}]
["Bob Miller","American History","6:30","PM","June",2007,"M, W","S222"]
[]
[null,"ACTIVITY DATE:","2000-05-12","2000-05-18","2000-05-25"]
[null,"ACTIVITY:","QUIZ","LAB","TEST","QUIZ","PAPER","TEST","PROJECT","LAB","TEST"]
["STUDENTS:","TOPIC:","Early American Exploration","Degama","Exploration in the West Indies"]
["LAST NAME:","FIRST NAME","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:","GRADE:"]
["Winters","Margaret","B-",91,82,"B+",92,79,100,100,88]
["Lowe","William","B",85,95,"A",97,100,91,91,100]
["Franklin","May","B",81,74,"C+",88,76,85,66,55]
["Smith","Vanessa","B+",77,89,"A",100,100,86,86,85]
["MaCabe","James","C+",93,94,"B-",91,82,100,92,93]
["Miller","Thomas","B+",76,79,"B",85,95,91,82,89]
["Paganini","Susan","A",97,100,"A",86,93,85,95,88]

{"sheet":"Totals","index":1,"n_rows":11,"n_cols":16,"rows_kept":11,"merged":[[2,0,2,11]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"NOTE:",{"$nulls":4},"ZOOM"]
["TOTALS",{"$nulls":13},"FOR REFERENCE"]
["LAST NAME:","FIRST NAME","QUIZ","TEST","PAPER","PROJECT","LAB",0,"TOTAL","FINAL GRADE","Percentile","Rank",null,null,"ONLY"]
["Lowe","William",{"v":91.5,"d":"91.50"},{"v":98.33333333333333,"d":"98.33"},{"v":97,"d":"97.00"},{"v":91,"d":"91.00"},{"v":88,"d":"88.00"},null,{"v":93.58333333333333,"d":"93.58"},"A",{"v":1,"d":"100.00%"},1,null,null,"QUIZ",{"v":0.3,"d":"30%"}]
["MaCabe","James",{"v":89.5,"d":"89.50"},{"v":89.66666666666667,"d":"89.67"},{"v":91,"d":"91.00"},{"v":100,"d":"100.00"},{"v":92.5,"d":"92.50"},null,{"v":92.16666666666666,"d":"92.17"},"A-",{"v":0.833,"d":"83.30%"},2,null,null,"TEST",{"v":0.25,"d":"25%"}]
["Paganini","Susan",{"v":94.5,"d":"94.50"},{"v":93.66666666666667,"d":"93.67"},{"v":86,"d":"86.00"},{"v":85,"d":"85.00"},{"v":96,"d":"96.00"},null,{"v":91.26666666666668,"d":"91.27"},"A-",{"v":0.666,"d":"66.60%"},3,null,null,"PAPER",{"v":0.15,"d":"15%"}]
["Miller","Thomas",{"v":86,"d":"86.00"},{"v":87.66666666666667,"d":"87.67"},{"v":85,"d":"85.00"},{"v":91,"d":"91.00"},{"v":79,"d":"79.00"},null,{"v":86.56666666666668,"d":"86.57"},"B+",{"v":0.5,"d":"50.00%"},4,null,null,"PROJECT",{"v":0.2,"d":"20%"}]
["Smith","Vanessa",{"v":72,"d":"72.00"},{"v":91.33333333333333,"d":"91.33"},{"v":100,"d":"100.00"},{"v":86,"d":"86.00"},{"v":81.5,"d":"81.50"},null,{"v":84.78333333333333,"d":"84.78"},"B",{"v":0.333,"d":"33.30%"},5,null,null,"LAB",{"v":0.1,"d":"10%"}]
["Franklin","May",{"v":87,"d":"87.00"},{"v":68.33333333333333,"d":"68.33"},{"v":88,"d":"88.00"},{"v":85,"d":"85.00"},{"v":73.5,"d":"73.50"},null,{"v":80.73333333333332,"d":"80.73"},"B-",{"v":0.166,"d":"16.60%"},6,null,null,0,{"v":0,"d":"0%"}]
["Winters","Margaret",{"v":41,"d":"41.00"},{"v":83,"d":"83.00"},{"v":92,"d":"92.00"},{"v":100,"d":"100.00"},{"v":95.5,"d":"95.50"},null,{"v":76.39999999999999,"d":"76.40"},"C+",{"v":0,"d":"0.00%"},7,null,null,"TOTAL:",{"v":1.0000000000000002,"d":"100%"}]

{"sheet":"Student Reports","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"merged":[[11,9,11,11],[12,9,25,11]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":9},"Teacher:","Bob Miller"]
[{"$nulls":9},"American History"]
[{"$nulls":9},"6:30","PM"]
[{"$nulls":9},"June",2007]
[]
[]
[]
[]
[]
[{"$nulls":9},"COMMENTS:"]
{"$rows_empty":10}
["FIRST NAME","LAST NAME:","QUIZ","TEST","PAPER","PROJECT","LAB",0,"TOTAL"]
["Thomas","Miller",{"v":86,"d":"86.00"},{"v":87.66666666666667,"d":"87.67"},{"v":85,"d":"85.00"},{"v":91,"d":"91.00"},{"v":79,"d":"79.00"},{"v":0,"d":"0.00"},{"v":86.56666666666668,"d":"86.57"}]
[]
[]
["Date","2000-05-12","2000-05-18","2000-05-25","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Assignment","QUIZ","LAB","TEST","QUIZ","PAPER","TEST","PROJECT","LAB","TEST",0,0]
["Description","Early American Exploration","Degama","Exploration in the West Indies",0,0,0,0,0,0,0,0]
["Grade",88,77,89,95.5,100,100,86,86,85]

{"sheet":"LetterConversion","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[0,0,0,9]],"flags":["formulas_cached_only"]}
["LETTER TO NUMBER CONVERSION"]
[]
["LETTER","LOW","HIGH","Average",null,"LETTER","LOW","HIGH","Average"]
["A",90,100,95,null,"A+",98,100,99]
["B",80,89,84.5,null,"A",94,97,95.5]
["C",70,79,74.5,null,"A-",90,93,91.5]
["D",60,69,64.5,null,"B+",87,89,88]
["F",0,59,29.5,null,"B",84,86,85]
[{"$nulls":5},"B-",80,83,81.5]
[{"$nulls":3},"SELECT FORMAT:",null,"C+",77,79,78]
[{"$nulls":3},"Use Plus Minus",null,"C",74,76,75]
[{"$nulls":5},"C-",70,73,71.5]
[{"$nulls":5},"D+",67,69,68]
[{"$nulls":5},"D",64,66,65]
[null,"WEIGHTING",{"$nulls":3},"D-",60,63,61.5]
[null,"PAGE",{"$nulls":3},"F",0,59,29.5]

{"sheet":"Seating & Reminders","index":4,"n_rows":29,"n_cols":14,"rows_kept":29,"merged":[[3,1,4,1],[3,3,4,3],[3,5,4,5],[3,7,4,7],[3,9,4,9],[3,11,4,11],[3,13,4,13],[8,1,9,1],[8,3,9,3],[8,5,9,5],[8,7,9,7],[8,9,9,9],[8,11,9,11],[8,13,9,13],[13,1,14,1],[13,3,14,3],[13,5,14,5],[13,7,14,7],[13,9,14,9],[13,11,14,11],[13,13,14,13],[18,1,19,1],[18,3,19,3],[18,5,19,5],[18,7,19,7],[18,9,19,9],[18,11,19,11],[18,13,19,13],[23,1,24,1],[23,3,24,3],[23,5,24,5],[23,7,24,7],[23,9,24,9],[23,11,24,11],[23,13,24,13],[27,7,28,8]],"flags":["formulas_cached_only"]}
[{"$nulls":3},"SEATING ARRANGEMENT FOR",{"$nulls":3},"American History"]
{"$rows_empty":10}
[{"$nulls":5},"Susan"]
[{"$nulls":5},"Paganini"]
[{"$nulls":5},"Great Student"]
[]
[]
[{"$nulls":3},"James",{"$nulls":3},"Thomas"]
[{"$nulls":3},"McCabe",{"$nulls":3},"Miller"]
[{"$nulls":3},"Practical Joker",{"$nulls":3},"Always late"]
[]
[]
[null,"Margaret",{"$nulls":3},"William",null,"May",null,"Vanessa"]
[null,"Winters",{"$nulls":3},"Lowe",null,"Franklin",null,"Smith"]
[null,"Dark Hair",{"$nulls":3},"Heavyset",null,"Funny Blonde",null,"Secretary"]
[]
[]
[]
[null,null,"Room","S222",{"$nulls":3},"Bob Miller",{"$nulls":3},"Days","M, W"]
[null,null,"Semester","June",2007,{"$nulls":6},"Hours","6:30","PM"]